SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.009194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281308 LIMIT 1 [ RunTime:0.001408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281308 [ RunTime:0.002476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124281,961216,955010,314296,956263,722810,627932,808057,60344,441590,393466,47907,694265,244560,880487,570225,116432,128400,509437,845884,392963,749773,281725,793963,956586,397266,521879,210477,602535,966782,856178,485428,4399,281928,523888,997552,175201,721643,936037,301907,222004,898500,971173,199770,788514,907788,403149,1035673,981036,376303,41708,512667,77419,761395,833838,760563,90249,192421,572655,350037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]