SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325060 LIMIT 1 [ RunTime:0.000934s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325060 [ RunTime:0.003255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475111,1025873,875748,364983,881880,757704,141069,782969,526456,754622,744251,787629,428679,387602,677251,61403,265126,596758,171503,566974,365526,124130,132354,770064,696617,358425,831293,901437,448469,294598,786942,1002115,992576,654159,165442,722530,533913,909768,180940,314481,1039913,735547,939815,71125,600909,665687,1036398,266511,564846,929554,247366,493389,287633,995671,885458,190027,620288,181594,264771,55645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]