SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809526 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809526 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372236,286652,615303,582884,7837,33716,383350,552493,674314,403531,686947,149110,315354,660410,722367,690339,804259,215105,386242,594471,430243,709970,688890,42484,1047018,354966,452930,695443,985257,265422,847820,741720,284190,892198,394813,229254,936116,815518,211025,491840,26465,466933,459452,356352,740171,123250,770451,991326,257786,1011238,744275,230689,740907,486154,795991,35961,775338,641232,395574,943788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]