SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505786 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505786 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791741,465642,992806,751621,647050,453757,571324,630582,858463,467103,285829,542618,393959,528126,964457,536819,355800,987928,448860,666564,744607,477119,479298,904662,890941,605312,809864,715811,931836,522538,169695,863208,991223,579336,396421,543264,808203,613647,261991,86487,312527,16132,898001,485832,289328,127343,138203,798277,140005,599898,350874,435911,420674,997722,832498,629001,70411,965493,661076,27023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000784s ]