SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596108 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596108 [ RunTime:0.002578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280020,702242,76163,599473,544864,794961,951696,868878,134312,457343,70049,142637,33379,506640,89505,89713,1013510,510188,502045,123891,848154,560347,420408,985451,741062,468548,442005,99282,548287,498581,344786,255780,601956,336356,469619,183846,862885,11742,661816,432758,802758,787705,372325,95522,265310,383098,680176,882929,748768,899944,720322,933167,703311,841996,802960,232354,39373,805686,884284,219186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]