SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547712 LIMIT 1 [ RunTime:0.004022s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547712 [ RunTime:0.005735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149516,276,220456,687225,741963,65947,819274,815462,116197,788934,692913,455729,7055,422319,73148,513733,404878,185164,916858,823548,828147,929470,523683,423652,515342,532142,935151,29652,248217,106918,104554,10931,948017,153940,950607,600098,734410,345838,441613,816665,775074,994487,690351,686893,922657,583505,252682,903367,1036660,439982,691615,557455,493383,758952,863171,542819,896338,295438,518033,853314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]