SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370236 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370236 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495379,653204,552313,104810,813212,810485,836146,182582,569939,642855,115235,302339,342717,813076,691496,828626,285720,73507,837144,324983,336437,145440,500895,740664,1048218,911717,901163,733305,169549,156210,340718,466587,626427,127616,834389,798508,782982,594753,582954,699066,352221,135961,304394,360476,76565,835871,897518,804992,386742,201025,763955,661012,91644,31180,137893,33439,84380,587684,894271,390620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000792s ]