SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807283 LIMIT 1 [ RunTime:0.001433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807283 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260108,1010090,457872,402805,312709,937856,141992,19502,43442,1019282,346950,70300,708309,662944,752219,1003149,186673,200382,309674,639227,297292,804457,648071,178070,971341,389979,180933,14457,938445,890185,490014,215982,692327,2792,774861,717220,33196,886244,598580,599862,235612,476483,198053,408412,336542,558394,1043456,172666,975155,977724,831908,807681,855303,661505,825489,606613,420749,604585,444499,134913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001512s ]