SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597580 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597580 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811232,160260,26098,554383,112869,258746,523851,392617,1038934,300906,349842,806457,432448,179369,199122,101615,15759,507489,482713,553124,1012302,212536,665168,876709,702486,626074,963489,1045169,779936,177456,218034,480054,690723,634230,363860,427973,544744,856561,1036035,9822,889433,666647,852338,658089,58254,783006,362226,211806,256910,233706,162040,529951,53238,980304,353318,318657,276610,97860,762177,26940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]