SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002712s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620912 LIMIT 1 [ RunTime:0.001615s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620912 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860703,894029,205863,203227,651819,138070,376930,53951,127185,650888,287848,46782,738241,752054,512809,431685,356773,578167,658627,934978,653742,996432,103430,926560,720671,68762,826821,312047,847462,1013246,937840,487175,961704,449046,824346,541797,466831,881249,773939,306422,168710,34645,827050,488457,779947,87982,517252,110360,479518,341802,444913,241675,626190,790278,292525,642991,521847,757690,515482,96936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]