SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 219809 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 219809 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046814,711306,1008722,901627,570773,826909,518993,139849,575746,123461,1008469,904677,470510,325414,597097,80591,602911,675588,458925,640587,32481,612420,701943,257362,578594,289829,878745,402470,314123,23847,321564,183844,959791,107949,489559,859330,128882,399782,710222,958085,260620,1015812,963769,248313,201616,389648,902030,34677,379808,671573,240487,605135,487217,643888,1041315,234534,427341,426935,278598,669377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 219809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 219809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]