SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512821 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512821 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356402,524964,844131,722394,429432,676049,936453,315060,611169,128952,857085,202859,115661,835164,712142,640506,129799,424530,844191,855939,84456,167493,50657,625398,277092,810379,132257,175372,912202,307494,5258,965687,100639,322964,655953,977733,665972,873149,417074,700230,531783,679184,100447,772630,371177,261684,644998,259354,814014,149623,989524,244580,655473,278725,276290,230164,976187,1043310,668795,356158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]