SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801810 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801810 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204406,901656,690042,494995,188410,903036,1047904,826744,420189,508443,996907,359792,279263,167499,899642,311710,121408,250269,495156,748870,508137,362106,56688,800484,267602,743869,854293,448172,251450,852790,221606,428953,909641,830846,907075,163503,801049,661241,666058,695676,751775,844213,437623,50959,63225,737235,2423,814697,198356,612625,388970,483293,118133,110832,199011,552535,518526,415228,5339,544462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]