SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456314 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456314 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83301,590848,812395,779153,104469,845997,481845,879956,126402,589048,465058,546471,779205,72528,295835,10717,826585,978388,825883,61946,902753,734445,533019,595443,462091,118670,407397,596978,590868,15706,549567,743896,376102,17587,156463,696315,387080,201330,657849,215756,28313,325334,200933,735389,423150,846093,57890,94780,772582,774750,12217,947681,790187,141639,512533,534896,481649,790717,954271,580225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]