SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310317 LIMIT 1 [ RunTime:0.001222s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310317 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193408,893707,338941,657005,598357,74869,631044,4955,345775,910591,252519,176021,951654,1035736,258456,565087,1045305,620658,754730,742214,199747,288479,775834,833479,113356,1021583,676207,684514,723422,296561,357327,377025,172458,627145,160850,432286,698883,513635,26813,935947,705753,396231,194987,864005,810362,151672,703127,121458,401306,672155,361705,893134,692529,560753,921642,146998,738773,1045733,687968,576942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]