SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804521 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804521 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659924,169039,1044826,745421,228517,1032112,1020438,150280,543999,447705,438700,400022,129820,134204,861621,166383,347286,302823,216002,578781,111145,339033,335324,23496,686741,520146,560717,856267,592803,637232,331868,417383,251966,659814,714120,940351,667637,533164,191561,233227,903781,733900,294833,267272,170113,765827,805272,282507,430992,248111,956203,162730,775278,357318,792732,929053,941803,408498,890111,983457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]