SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106309 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106309 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835120,83682,639927,50649,116898,9683,325563,4077,925786,685705,194817,29286,949425,134059,225238,282614,367380,886137,689454,482458,709136,241139,918033,156674,147809,247206,761146,216408,168879,735377,11235,21104,1006708,219587,877297,115097,624223,148895,248603,714621,986813,224891,418899,970747,631263,337987,489231,67240,145981,657834,224277,231915,746112,658450,724769,615947,103327,718694,562311,515215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]