SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195515 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195515 [ RunTime:0.002624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587407,828302,137664,307684,149440,436129,393658,48520,770535,430641,540180,700917,383587,360236,906723,850722,713501,298837,308255,135724,1029650,401915,507375,743695,491340,995105,165842,674889,661177,540185,959362,152603,709130,64208,970768,940098,425509,424809,705821,592365,660000,985487,117044,679267,825488,990351,898226,229956,223936,1033441,123827,1035522,643785,576052,98721,162930,495086,160514,732944,262834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]