SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488968 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488968 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722697,885525,498259,944505,625107,847270,575022,307998,700116,1027488,961285,206253,693526,579392,967590,124430,680785,623927,289964,782883,895644,760623,826524,742782,144201,604331,832437,507273,717190,136446,718015,262691,454216,26704,954598,148409,54407,365956,915632,197468,392947,802816,97442,7990,647690,81750,544672,695830,639347,723125,975094,22819,723593,207804,494166,930966,178342,945522,817599,142699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]