SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 823518 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 823518 [ RunTime:0.001418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308342,1083,192522,840387,132261,1026180,13102,81477,1027828,517155,4922,1000839,751095,740627,349518,709836,945831,447728,1042005,869199,539762,376616,638126,155225,957855,935972,377047,991031,234511,46778,739244,494107,880878,326377,277547,541124,942918,978521,728611,399955,75453,137797,959019,696487,186723,525448,1529,307674,792598,389291,996172,979190,980870,890764,507968,892271,28829,863677,563020,31153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 823518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 823518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]