SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 375014 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 375014 [ RunTime:0.002814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436983,555581,285498,398757,946375,490144,320379,155196,892780,623873,450426,48648,963175,337888,379586,266754,892897,1039298,881452,424876,497696,696246,265174,171016,384098,778661,623878,233145,893371,146032,118870,383497,130766,401589,779441,903642,1038589,10925,327014,809469,221476,570895,596582,410156,987825,536970,467221,61156,471485,45566,602330,1007461,875618,206114,266649,626320,819811,825784,156174,26744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 375014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 375014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]