SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51791 LIMIT 1 [ RunTime:0.001714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51791 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940613,862991,314369,696939,130369,90213,632504,8955,271824,263170,374653,260995,860273,104061,204725,207137,200044,100773,943048,225620,815547,78987,306604,6029,698645,682387,979331,100687,972829,245827,220389,657345,647387,318798,250731,310229,257442,174799,437428,818756,924059,429319,820141,528570,250405,158530,216543,332468,685891,361194,783071,491924,74314,873119,385052,869955,103463,919812,1022743,205589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002807s ]