SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343194 LIMIT 1 [ RunTime:0.001347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343194 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259111,316475,395622,170309,844563,116862,998221,1015159,1046923,949670,1040937,562491,548885,1042988,95074,196135,463471,1011189,509563,289377,860770,742018,619238,1014911,265345,446188,699867,812140,169943,580540,110500,81824,267406,171238,32901,78842,703925,862259,890146,658228,373636,264649,395245,216194,39954,981056,867426,512215,991955,525092,57842,682900,1041256,244660,132422,664319,626202,1018630,744579,485542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]