SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291412 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291412 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365726,870788,343239,279576,512775,626508,625710,969315,380353,373575,243601,164776,616453,531838,360069,806978,929028,183631,154942,796962,872292,362608,154100,1019357,719030,634376,174533,109330,474578,190459,44813,401165,311358,383093,368914,785260,414549,956820,475248,990692,159114,17697,752840,163084,456983,555074,678164,238539,112302,835685,281312,188688,57742,795650,205783,546128,324259,378501,877049,180236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]