SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498090 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498090 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281662,28233,484850,384046,176894,388631,368086,110676,850310,154724,479664,850141,802615,1000312,473392,545113,743773,742778,1015860,972890,73056,112668,508467,132531,921416,228059,144851,627762,154,14079,1043127,138771,485317,899243,308517,184651,661507,457924,473422,225174,25102,675573,879666,637979,424473,624368,511556,933628,159290,235519,539705,941989,637379,861414,239606,376740,96269,136155,606567,669488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]