SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204003 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204003 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107978,59840,120375,875717,167590,584824,217484,392659,685762,66877,1039639,775503,493140,590232,986469,1046874,525557,424001,934942,436299,468697,658997,123219,349100,229142,340447,993923,898615,705083,628821,249489,153834,978323,689978,203659,765536,310771,232940,445556,818114,16631,761338,592441,612909,792388,379244,172817,350242,964373,859216,902991,678875,955084,876058,652248,834065,105586,991620,236732,749613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]