SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502608 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502608 [ RunTime:0.003525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30291,386524,926622,514533,599232,287472,374159,889975,421224,553108,842189,162956,940014,358438,529894,1002214,430460,82397,568688,116256,286078,322435,214726,346524,845134,1008417,507142,826987,470918,271532,474910,762761,639588,897278,287229,779266,300056,56291,35840,705801,141623,13639,519943,428746,963152,606972,427924,848772,505863,640320,144861,115004,984436,303991,353923,542630,619768,734209,984451,1034811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]