SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467781 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467781 [ RunTime:0.002739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359131,858995,845256,309510,543936,23824,554390,796823,457441,890528,390468,52404,770571,907835,209727,443958,560277,556148,480934,525454,570599,762344,604823,361977,441287,449165,994246,417677,126187,778914,440639,329746,453195,243025,470369,109946,120443,426788,1044552,836311,367996,562830,1048651,83617,760504,752688,538119,261347,563126,1000194,460202,111757,977141,703232,681944,515462,348773,6266,572863,1024606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]