SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302811 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302811 [ RunTime:0.005741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698948,623892,888403,507969,126909,371800,721455,483176,907164,492219,890402,117342,535213,551096,442363,450275,892783,958018,425547,1014481,606281,37146,334933,679025,47632,312529,389368,907911,682626,35830,258152,170205,848617,685940,1003487,555495,1029617,1038477,894257,999067,665031,69188,846553,336082,134907,70100,684452,1040934,601671,525651,779799,410076,605935,232472,319126,740096,216969,1004540,698659,238287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000967s ]