SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410715 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410715 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545089,186812,767078,466070,773542,570077,446265,188101,988205,846232,107943,530406,966106,649150,893550,208313,337025,511472,1008306,982178,246656,722535,206771,709759,670041,950040,273543,509425,227219,960242,458320,627347,1000061,326010,755050,395416,878188,1028004,151382,81016,580643,917585,177296,1043775,588141,899952,607131,759355,971089,816410,657190,489908,272099,82977,736582,1047491,247826,58815,398760,167246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]