SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481920 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481920 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362097,958758,1046127,489754,778525,321528,379371,213962,451796,334459,279631,368248,706191,613694,851880,344004,722813,1030019,977258,271190,1036562,888190,976870,483166,473102,1021574,1013277,967532,861186,770497,89125,735595,425918,873236,928630,881690,156009,580336,91535,173389,535449,326490,265765,1022381,991012,402117,201136,1023732,11328,376088,610871,196669,482380,773348,173846,74324,792379,545034,390540,295875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001539s ]