SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308918 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308918 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475569,268161,493694,158934,806564,801489,769277,877087,941799,321908,837337,164797,702770,803718,290914,562307,546439,420043,1027632,509785,718285,197279,790229,569981,283663,327980,978633,254321,310481,13907,170595,819133,234695,833677,425277,965349,45606,69049,666744,855530,1027219,576686,115899,739025,844376,536020,257524,149740,83823,827494,331586,431466,63578,363690,937144,645244,286176,195584,204001,33188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]