SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648601 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648601 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342053,557829,362393,353100,19126,666611,44214,894969,510445,243269,886927,438726,429811,829946,935548,462153,291948,943150,856231,757878,201121,42670,433283,318299,641251,220144,726213,228277,172967,1022395,125147,848060,206046,378692,775402,40548,278478,571757,280991,43114,251394,151681,708035,475673,883659,463328,1004904,531401,578889,468498,10062,106754,246641,528427,594101,736866,471628,579107,256454,390695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]