SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544314 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544314 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586189,226391,377771,40284,351874,290077,347325,767279,1017783,475037,1040747,195177,614883,176370,662947,709200,577472,362598,415146,768382,930057,457411,407077,490655,910021,703633,50921,894164,689172,952885,657612,1021549,848880,971013,1039571,790995,715511,467088,448616,469124,824422,809978,1016740,1008546,408492,566813,128062,588866,487860,797263,752420,1003678,84694,697492,408964,219042,85882,187266,723837,519880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]