SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490184 LIMIT 1 [ RunTime:0.000744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490184 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243884,363374,1014018,354866,989853,921012,331501,500166,254733,1041107,493845,173425,819078,415371,500589,1040247,73294,84927,671450,355340,978853,1043396,246146,281605,886230,645742,359545,196790,157268,283038,576762,154335,108176,353250,268207,1042793,649690,458515,269079,1007142,901081,957193,730782,924367,635647,281154,730954,894881,32037,380122,703312,260719,932375,739660,745656,780843,834239,43522,849024,266439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]