SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1064 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1064 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1998,155497,1020056,942762,361035,1001167,203438,710029,73982,291775,957880,883993,861246,740322,671494,377704,979749,85532,106574,419922,862274,664802,711137,476178,357215,706382,176169,972759,453523,841478,48727,86457,388773,453988,500594,630424,347373,332201,56929,113226,713232,606490,832379,726375,312098,16184,775917,821426,640575,564317,1014172,639462,108672,918357,943300,868835,166383,505819,373721,664693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]