SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040324 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040324 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520446,213634,412979,374196,18606,294371,534370,119134,876423,525886,113478,424091,389785,984219,326450,120601,101439,180049,819582,762843,99802,988447,50352,321987,284188,877133,958913,17564,27439,992640,699747,460016,338283,5273,965063,181084,28102,287521,258551,528073,182491,596654,443390,383335,382350,282002,864191,525367,314267,945406,70396,727352,190735,17886,328878,722271,594064,387787,671414,731239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]