SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40169 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40169 [ RunTime:0.004183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198914,288332,78831,576026,312514,79992,241274,240695,479696,444264,948498,383482,495660,4517,820938,779592,935876,163079,520157,451868,692579,629589,398692,213670,443357,136103,456166,359988,519360,874156,1004698,198041,392725,524733,235330,1002998,767813,377837,429022,157926,842135,799191,785284,922466,789800,332130,778572,821156,898697,1042061,141572,629690,412926,754349,299427,161170,911771,430858,287984,1046620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000828s ]