SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110025 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110025 [ RunTime:0.002504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138915,267721,358814,269408,196609,128133,287617,790446,321710,166574,73159,933710,619614,976513,893030,378613,296711,648690,191736,428115,947529,252507,954532,176142,335988,741338,936257,740183,600835,142305,722700,451583,1020515,40893,865758,42605,669388,858799,172081,186530,196490,575591,71422,1014598,721990,567981,346409,267741,27583,596416,381667,357587,1048484,180723,775158,248345,939354,840871,673877,799411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]