SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549580 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549580 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972951,692084,881120,262260,73095,592342,561748,943952,139092,664600,1029460,846388,134607,522110,204011,274774,479936,682188,523343,871169,252429,253780,494884,36666,991993,712216,30434,76145,533722,413671,897451,935474,968080,746364,1023787,433907,748679,125839,530894,494326,738524,854156,1018212,732164,720432,42969,325510,186883,277303,373493,143097,534229,450600,102838,731936,347759,1018817,161927,492359,351481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]