SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445479 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445479 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44293,231684,258572,400944,97241,303989,104815,613632,949209,15976,289046,980629,524769,711555,875864,186275,508911,237312,866253,200850,644018,630817,569947,940247,584781,552564,384834,528281,511029,435287,370732,268330,863097,188658,699749,601789,888553,732180,181082,925307,102292,694449,809274,26677,443832,585102,377335,601296,367800,563518,331431,306076,702962,368976,462477,306754,869676,449760,134504,88454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001400s ]