SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803480 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803480 [ RunTime:0.004377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631567,190485,623854,1021219,374902,452241,205348,999134,973070,12908,708594,925805,1020189,829778,964658,651937,180668,233395,270263,393240,1039933,578638,848937,843935,144699,571372,518896,1029040,861212,738207,9327,862147,160975,770585,707737,490611,52986,345908,885085,659308,744791,735668,212631,154852,279911,393273,858818,323823,542743,269330,922099,367038,557916,542122,261551,19779,1001046,182347,192464,134467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]