SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174683 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174683 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191852,735403,2970,48954,273276,231494,352243,84548,704959,522987,874684,779144,879362,419914,924555,1018846,939358,418152,783004,831350,235458,841631,1018765,380586,608111,445158,734015,375908,771210,996595,600338,249120,893042,808683,828105,151061,909449,576448,571101,890972,665163,329898,474597,127826,252033,660147,479347,1033655,100306,624747,302354,808308,863106,581994,80823,1030731,1034292,767201,757307,43185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]