SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304481 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304481 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67654,1032645,333903,933394,642576,227310,1021889,258872,485475,197672,910695,183344,717344,533136,993529,451809,751618,940338,732666,557872,1013260,568641,859390,987349,487381,198391,789738,443559,300032,861464,650632,799758,257541,547991,874289,577905,619261,593722,405616,622165,87151,999347,712178,333341,483784,715208,1033931,566589,970490,370269,277352,318564,212483,306801,519723,360322,44181,206908,76196,497040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]