SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 678906 LIMIT 1 [ RunTime:0.000803s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 678906 [ RunTime:0.005536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810787,1001464,659148,353058,670080,208988,540741,581628,104233,710417,498169,656041,948760,453862,594545,1017787,497478,1032172,838974,388330,598559,92103,354333,388973,353379,206481,673325,36420,565200,964972,1003483,480209,185492,642097,716835,103927,987163,773631,734089,845663,381518,431347,276961,530771,680430,476296,765361,946913,238382,557882,225775,506146,580691,128719,148536,653621,197070,807187,130101,826231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 678906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 678906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001616s ]