SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445307 LIMIT 1 [ RunTime:0.000729s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445307 [ RunTime:0.004793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621882,760380,503370,657723,1043594,566906,138085,186798,74639,800216,577142,958132,566213,796443,907592,291116,798262,888256,1025871,829430,873408,603933,747492,926339,344169,383123,120664,488564,36195,205234,861728,658746,19036,411659,286240,174439,1033652,313483,946074,1013662,117238,865992,605029,812000,439752,878835,408352,374630,1034421,482909,314755,629199,148364,361190,37255,105763,979622,178760,736444,26417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]