SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510856 LIMIT 1 [ RunTime:0.000914s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510856 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107698,234021,893579,208976,746713,991221,487443,981496,221382,112579,572116,651603,479333,375982,749261,231391,799257,696690,97519,687773,325071,159176,296876,60505,830843,578528,947480,945371,301836,1011360,448002,835426,275283,440544,719007,898852,150631,544686,506534,925812,464838,536945,769862,191418,486529,228657,75172,204492,828458,379432,1036508,712459,272650,958413,846533,65370,937701,355097,850399,276094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001012s ]