SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498016 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498016 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278406,138970,127852,131246,743418,221216,115707,261307,527794,638949,287863,862853,236190,342252,943995,638406,30887,128487,151041,523259,699060,767509,403761,150238,913976,880115,711767,752003,322118,750279,57540,912938,413800,631703,852177,534000,803481,790271,930011,392932,210311,178328,706477,86605,331211,754698,199632,319425,190249,571572,176644,457511,714517,457818,533207,939459,343518,745039,697462,279075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000828s ]