SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406013 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406013 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014028,117967,920337,648916,500731,200674,1025367,402951,1031125,159883,244767,608180,911233,165444,238067,206547,1042005,522004,431803,1025582,882752,295692,645696,941796,922114,379689,716591,79619,353571,842283,235897,266873,1045744,343454,267089,490635,208630,736510,403458,967061,592289,975723,486409,46596,408789,422346,898021,29950,581794,827710,549388,817409,420067,63333,821982,74096,140742,978901,8975,1037890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]