SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401329 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401329 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426632,215941,188107,588144,112882,471630,938219,921138,681609,679603,144025,804127,76893,71841,133837,595841,886575,438812,660063,231436,117849,847371,920101,315277,443548,298776,433384,718024,637543,712363,879664,370297,250049,448633,298857,311495,108578,944981,916775,498705,400526,392014,227356,541704,208832,952123,848217,460364,114537,107544,540448,6106,489010,445411,828361,390579,251131,921630,371963,715003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]