SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 776300 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 776300 [ RunTime:0.003346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727620,12688,419412,11173,743325,201400,79803,851546,1034161,800838,565374,336577,351802,414284,521662,668883,1046155,509931,777210,595442,436299,154298,135672,378865,473214,487900,368936,547632,284569,104036,53711,695732,500623,173778,913113,802735,402636,390810,899247,1011018,693047,594461,708948,1024314,397685,77118,943185,352569,179219,28239,722291,294729,292940,177941,278040,833625,924966,374923,23859,572983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 776300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 776300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]