SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 213178 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 213178 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587982,454461,72191,807545,585880,291519,264468,998233,285055,187316,230425,831454,210165,1045273,48196,91744,190572,355770,750148,656694,830369,222640,886576,220654,954269,481429,631855,462264,974752,21510,890949,453789,659385,111715,11843,839041,32019,774860,786813,145292,518576,882723,404608,946606,605537,393615,609352,438940,723683,455591,960911,1029555,635908,869312,787780,409336,121713,130158,820287,340642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 213178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 213178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]