SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040969 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040969 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510211,619780,1466,578858,198325,630305,699727,955316,110796,149057,883231,810132,726273,35034,125386,1001227,503166,658571,994556,752381,926698,990753,1041951,698514,791827,139578,223238,452917,900512,564515,746512,702166,1032607,66279,992983,202131,979642,452813,405929,585043,891218,59647,319432,991138,344912,383773,17813,763952,208409,968638,854247,612680,41756,90006,128731,733146,880141,441370,797371,696418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]