SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433740 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433740 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483528,95041,652354,522619,680743,189237,159639,566223,1040938,128302,597676,112795,1005913,469645,260835,904211,512423,709056,543694,814838,440017,909693,165100,298473,788690,652429,917240,876824,977852,962936,37111,620720,469555,240847,473936,366084,985577,553422,754670,282318,511537,963801,131899,194493,1007296,177407,120420,859571,881703,842461,308966,472203,209897,450917,942833,635724,358090,877962,484169,260591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]