SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016627 LIMIT 1 [ RunTime:0.006824s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016627 [ RunTime:0.007670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467133,524176,902432,911398,673182,967946,556183,185900,322290,569613,873400,363093,700234,630753,336701,77090,287242,240280,908974,313790,756036,195169,839913,363843,458469,550271,786266,731634,978868,981679,173008,40018,723083,483855,533499,307180,857101,714453,465723,347740,165636,733538,969019,717023,701866,268785,63033,78422,980847,654976,880580,630923,575942,626833,577718,137335,7253,389945,1014300,242510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000875s ]