SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390497,14343,601820,16097,889673,946166,962903,345475,504578,1038744,709116,301542,1020538,992427,91577,242046,86499,51422,404483,323632,124149,249382,706166,691563,1021146,832027,248289,608745,237683,1003221,157175,473445,763700,577295,1046426,88781,124142,49993,874942,40104,459996,774442,66730,39356,715485,616583,995134,622137,256742,189091,887769,582213,1034887,431,991042,68285,220388,862409,809384,1007993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001486s ]