SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410061 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410061 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184365,567754,558307,543894,206420,907298,292250,1006483,957492,998597,544815,917549,661026,595378,956794,948605,81794,377268,706695,1035316,702847,202115,881221,328544,789390,232508,906340,696887,889860,902996,62662,980534,113176,774120,588604,458460,1030518,919599,237267,25340,342826,918338,267550,392562,659810,679702,464126,725260,1008906,927139,116353,100668,644065,444494,1044917,16397,570605,387557,602915,590648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]