SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 925017 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 925017 [ RunTime:0.002699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525751,864803,891802,748961,569118,507627,561780,147644,281687,152876,443806,966050,498575,137214,817481,68586,745040,906390,251137,263982,874769,1010188,817188,551621,917918,989327,170311,741616,125153,564905,806586,903185,292876,87098,395647,640204,940689,319795,115867,997718,157228,446313,856040,396588,844175,287694,377594,197325,456959,1041628,288638,33297,1038986,546530,484977,356100,552109,279824,799366,337251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 925017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 925017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]