SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556254 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556254 [ RunTime:0.002433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282884,400340,459650,29847,170290,424981,401863,28386,795001,777903,559482,402661,301777,313552,347651,423295,587230,881361,974722,842728,1005794,376656,35281,214709,66496,605367,459796,462021,842994,16069,647473,119526,91752,624955,742084,1024153,945175,635330,604139,159794,348171,721940,417466,838727,901933,30180,376378,729279,669923,440770,199242,782205,477523,753878,704785,546792,670241,599063,866328,996064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]