SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015166 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015166 [ RunTime:0.002788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841125,1007964,404240,299843,773794,317418,1035134,821205,336867,891920,992418,756857,803550,940756,123103,481907,959243,950080,387963,739200,903062,347088,942776,580267,158284,579385,766102,591006,494292,619701,339775,565542,324965,765730,207580,552627,381595,461175,1004479,751871,445257,531344,74896,851604,82260,258161,30333,768138,106004,535496,688434,943682,586716,31941,438800,673872,543133,38621,371931,122269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]