SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534236 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534236 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568110,835667,1025612,390261,425750,213987,565007,987887,660039,566584,631601,26593,1001743,899262,184979,1025374,91537,365415,775381,1010132,821071,258872,686231,725105,289501,1012307,223784,62773,56397,104522,535387,771456,382630,34822,216611,227955,31824,645257,408110,353382,342958,249275,48972,37930,14627,283879,905040,459098,99676,470438,85964,223555,28926,1027610,994887,896487,709387,669168,40152,93764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000998s ]