SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804481 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804481 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400167,1004704,962219,846972,37439,790447,163023,710334,69095,1034089,353995,713998,520300,575881,889245,758437,510683,14744,819893,501310,245266,54978,330821,295123,501786,265944,468083,422459,888675,118251,548258,927259,740384,868688,158373,142023,663926,716761,874134,361598,110632,1034138,345444,450000,90937,24759,284925,284304,315160,209512,663808,462668,997406,187495,973062,198254,398099,334457,66754,548664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]