SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45105 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45105 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514272,412032,625707,471161,329235,732580,32681,231802,366143,71314,891315,677554,543107,153321,372380,595691,449328,8236,190294,312652,82556,479418,501078,206387,47678,1032702,154280,400289,466107,340639,671781,188905,53810,894177,600697,303191,403373,183548,523892,244379,539550,242401,153458,636784,19887,355566,250524,569447,889348,194487,181250,319996,771767,277894,164719,488644,335419,415232,14436,229425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]