SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668201 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668201 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354975,195058,602074,973543,595342,1009777,508617,245059,830788,374816,712720,92509,261103,402780,1023318,383931,825302,537290,231155,679042,151920,318117,15963,654463,461341,638144,521697,580094,566980,60594,36896,524172,324959,274139,641686,312478,360088,639617,298344,1005690,337645,98879,51071,972852,506043,970079,633225,885680,612498,283018,533575,231405,1025929,211109,41162,816458,502584,192429,252937,825847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]