SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018350 LIMIT 1 [ RunTime:0.001050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018350 [ RunTime:0.002644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976264,267516,233505,984985,846324,1029880,297981,126956,749388,916145,29926,493944,210678,171994,469525,573205,210858,221158,738255,65339,482670,1032252,505366,365180,395099,958645,871897,626548,375181,154123,1044174,144810,178307,96420,1038660,772222,237476,970864,685668,344557,1001775,362772,996980,142079,814365,373641,798644,306441,953193,506401,844524,197987,904580,86964,27891,468819,733247,735821,51549,551888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018350 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018350 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002201s ]