SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195472 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195472 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802503,897406,979865,1032310,898625,42871,929671,976532,415724,355132,784167,252268,616459,48212,469905,823862,880650,147338,384910,640312,584193,61340,361750,428443,661784,16914,298810,304636,626586,644395,394255,835326,388272,802764,19647,443296,598360,809443,940464,563670,330160,733820,670185,945350,1010276,707635,162254,741370,71949,511980,686355,994345,904455,34364,461780,365854,208631,49604,772326,930443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195472 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195472 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]