SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592370 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592370 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545495,842334,75688,418812,652894,401626,796616,268913,121416,1026602,295417,724616,182143,689515,459226,267536,359011,113051,973998,1020279,904747,191777,553930,441817,997649,13415,437315,466041,961743,890831,111733,385733,252213,409134,969039,401806,417970,848676,465338,207445,468430,308121,319291,951424,172539,159342,873338,41185,500892,877881,25269,509364,121125,566266,122558,379660,155470,836575,445999,491820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]